
/***********************************************************
* Purpose : Get Category_Question by Name
* Author : NuoiNV
* Date: 25/3/2012
* Description: Get All Category_Question by Name
*/
IF EXISTS ( SELECT * FROM SYSOBJECTS WHERE NAME = 'sp_GetAllCategory_Question_ByName') 
BEGIN
	DROP PROC sp_GetAllCategory_Question_ByName
END
GO
CREATE PROC sp_GetAllCategory_Question_ByName
	@Name varchar(50)
AS
BEGIN 
SELECT * FROM Category_Question where [Name]=@Name
END
GO

--exec sp_GetAllCategory_Question_ByName 'Events', ID